Areas of the Pivot Table
The pivot table view can be divided into four main areas, as illustrated in the picture below:
The following areas can be distinguished.
Row Area and Header
The row area is the area of the pivot table that consist of the row headers (the row indices) and the elements that are structured in a tree-wise manner. Standard tree operations allow you to open (and close) levels in this tree.
In the figure above the row area is indicated by the blue rectangle.
Column Area and Header
The column area is the area of the pivot table that consist of the column headers (the column indices) and the elements that are structured in a tree-wise manner. Similar as with the row tree, standard tree operations allow you to open (and close) levels in this tree.
In the figure above the column area is indicated by the red area.
Grid Area
The grid area is the area of the pivot table that contains, as a kind of cross product between the row and column area, the cells with the actual data values.
In the figure above the grid area is enclosed in the green rectangle.
Outer Indices Area
The outer indices area is the area of the pivot table that is positioned above the other three areas. The value of the outer indices can be changed using the drop-down list that is accessible through the small button in the outer index. When the value of an outer index is changed the resulting pivot table is updated accordingly.
In the figure above the outer indices area is indicated by the yellow rectangle.
Special Buttons
Besides the standard buttons to open and close branches in the row and column tree, the pivot table contains some non-standard buttons to access special features:
This button in the upper left corner of the pivot table object provides access to the End-User Dialog dialog.
This is the Load Layout button, that allows you to load a previously saved layout of the pivot table. See also: Load a Layout .
These sorting buttons appear when you click in any of the headers or in the
'leaf'
nodes of the row and column tree. See also: Sorting .This is the index filter button, which appears when you click in any of the headers of the row or column area. When clicked, a filter specification popup menu appears. When you have specified a specific filter, then the button changes to
. This button remains visible, so that you can see that a filter is currently active. See also: Index Filtering .
These small filter buttons in front of both the row and column tree allow you to enter a so-called ‘fixing’ mode in which you restrict your view to certain elements only. When you press this filter button checkboxes
will appear in front of every element in the tree. When you change back to ‘normal’ mode (by pressing the filter button once again), only the elements that have been checked explicitly will be shown. The exception to this rule is that whenever no child element of a certain (visible) element has been checked explicitly, all elements will be shown.